package utils.db.api;

import java.util.List;

import pojo.EUserType;
import pojo.User;

public interface IUserFetcher {
	public User getUser(String email, String password);

	public List<User> getUsers();

	public User getUserById(int id);

	public List<User> getUsers(EUserType type);
	public List<User> getUsers(EUserType type, EUserType typer);

	public boolean checkUserExist(String email);

	String GET_USER_BY_EMAIL_PASSWORD = "select id, firstName, lastName, password, email, type, phoneNumber from users where email =? and password = ?";
	String GET_ALL_USERS = "select id, firstName, lastName, password, email, type, phoneNumber from users";
	String GET_USER_BY_EMAIL = "select id, firstName, lastName, password, email, type, phoneNumber from users where email =?";
	String GET_USER_BY_ID = "select id, firstName, lastName, password, email, type, phoneNumber from users where id=?";
	String GET_USERS_BY_TYPE = "select * from users where type = ?";
	String GET_USERS_BY_TYPES = "select * from users where type = ? OR type=?";
}
